USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[SuicidesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.SuicidesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Suicides Table Insert
-- =============================================
CREATE PROCEDURE SuicidesInsert

			@SuicideId int,
            @PlayerId varchar(30),
            @ClassId int,
            @WeaponId int,
            @DateTime datetime,
            @LogId int,
            @RoundId int,
            @MiniRoundId int,
            @MapId int,
            @Pos_x float,
            @Pos_y float,
            @Pos_z float
	

AS
BEGIN

INSERT INTO [Suicides]
           ([SuicideId]
           ,[PlayerId]
           ,[ClassId]
           ,[WeaponId]
           ,[DateTime]
           ,[LogId]
           ,[RoundId]
           ,[MiniRoundId]
           ,[MapId]
           ,[Pos_x]
           ,[Pos_y]
           ,[Pos_z])
     VALUES
           (@SuicideId,
            @PlayerId,
            @ClassId,
            @WeaponId,
            @DateTime,
            @LogId,
            @RoundId,
            @MiniRoundId,
            @MapId,
            @Pos_x,
            @Pos_y,
            @Pos_z)
END
GO
